2015-07-22 - 20564 - Create a Historical Cube for SSL Data #SalesDistribution
SPECIFICATIONS
20564 - Create a Historical Cube for SSL Data
Purpose
Need to delete & reload the current data request daily wiithout deleting the historical data request in Service level infocube.
Admin Info
Purpose
|
Need to delete & reload the current data request daily wiithout deleting the historical data request in Service level infocube.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
07/16/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZBI_DEL_REQUESTS, ZSDC_SSL
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
04
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
24
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
04
|
|
TOTAL
|
40
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
As the current volume of the data in service level Cube is around 10 billion records, the data loading takes very long to complete, causing the delay of the reports.
In Scope:
Service Level Infocube and its regional versions.
Out of Scope:
Other Sources.
Solution Summary
1. Need to create a ABAP program to delete the requests other than Historical data requests in the service level Infocube.
2. Need to change the service level process chain & insert the ABAP Program before the DTP load.
3. Need to make the necessary changes to the regional service level cubes & process chains.
4. Need to test the changes in BPD & BPQ.
5. Need to collect the changes into the transport request.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check if the ABAP Program in the process chain faiils, if there are no historical data requests in the Infocube.
|
Process chain should fail if there are no historical data request in the Infocube.
|
2
|
Check if the ABAP program doesn't delete any data if there are only historical data requests.
|
ABAP program should not delete any requests, if there are only 2 historical data request.
|
Solution Details
1. Need to create a ABAP program ZBI_ DEL_REQUESTS to delete the requests other than Historical data requests in the service level Infocube.
2. Need to change the service level process chain ZPC_LOAD_SSL & insert the ABAP Program ZBI_ DEL_REQUESTS before the DTP load.
3. Need to make the necessary changes to the regional service level cubes Z_SSL03, Z_SSl04 & Z_SSL05 & process chains ZPC_LOAD_SSL_EMEA & ZPC_LOAD_SSL_EM_JAPAC.
4. Need to test the changes in BPD & BPQ.
5. Need to collect the changes into the transport request.
Issues
None